﻿IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'P_GetBasicReferenceType')
BEGIN
	DROP  Procedure  [esf_sso].[P_GetBasicReferenceType]
END
GO

CREATE Procedure [esf_sso].[P_GetBasicReferenceType]
	@pID INT
AS
BEGIN
	SELECT * FROM BasicReferenceType WHERE ID = @pID
END
GO 